Create Foreign Table Inventory

The Create Foreign Table Inventory button will only be enabled for Datum Network Types. It allows you to create a new asset/inventory type as a foreign table, based on the selected Datum Network Type which can then be used when defining queries. It will create a ‘Continuous’ Asset Type for the selected Datum Network Type of category 'X' - Generated Exclusive Inventory Type. The Asset Type Name will be defaulted to the Network Type, but this may be amended using the 'Inventory Type' field in the 'Create Foreign Table Inv' dialog. The Inventory Type description will be in the format of: FT Inv for {Datum Network Type Description} e.g., FT Inv for Classified Roads. This Inventory Type description may be amended if required.

A foreign table join will be created to a database view. The naming convention of the View name is as follows:

V_NM_<Item code>

For example: V_NM_CLAS, where CLAS is the Inventory Type code for the Datum Network Inventory Type.

The remainder of the Foreign Table join definition is as follows:

Primary Key Column NE_FT_PK_COL
LR NE Column Name NE_ID
LR Start Chain NE_BEGIN_MP
LR End Chain NE_LENGTH

An Inventory Attribute will be created for each of the flexible network attributes defined in the ‘Type Columns’ field for the Datum Network Type in Network Types, as well as Attributes for ‘fixed’ attributes such as Length, Admin Unit and Description. Any unwanted Inventory Attributes may be ‘End Dated’ by selecting the required Attribute and pressing the Delete button on the menu toolbar.

The table below displays the Asset/Inventory attributes that will be created:

If any of the Network Attributes defined in the ‘Type Columns’ field for the Datum Network Type in Network Types are validated against a System Domain (maintained the Domains form) an Inventory Domain will be created and the Domain associated with the appropriate Attribute allowing a list of allowable values to be displayed for the Attribute when defining a query such as PBI or Merge.

The Inventory Domain created will derive its name from the name of the System Domain. If an Inventory Domain of this name already exists, the Inventory Domain Title will checked against the System Domain Title. If the Domain Titles are also the same a new Inventory Domain will not be created and the existing Inventory Domain will be associated with the Inventory Attribute.

If, however, the Inventory Domain and System Domain names are the same but the Inventory and System Domain Titles are different a new Inventory Domain will be created using the following naming convention:

For example: CLAS_CARRIAGEWAY_TYPE, where CLAS is the Datum Network Type and CARRIAGEWAY_TYPE is the System Domain Name.

Note: If additional lookup values are added to the System Domain these must also be added to the corresponding Inventory Domain.

Note: An appropriate User Role must be defined in Order for an AWLRS User to have access to the Inventory Type.

When the Create Foreign Table button is pressed the following dialog is displayed:

Inventory Type (Required): The Inventory Type Code will default to the Network Type Code. This may be changed if required. A maximum of 4 characters is allowed.

Delete Inv Type if exists (Yes/No switch): If the switch is set to Yes and an Inventory Item type of Category 'X' - Generated Exclusive Inventory with the same Inventory Type name already exists, the Inventory Type will be deleted.

To create the Foreign Table Inventory Type, press Save or Cancel to close the dialog.